Appendix B: Cell-Specific Editing Guidelines

This table presents the different cell types and how to use them.

Cell Type Usage

Mandatory

Indicated by an asterisk in the column heading. Leaving these cells empty will give an error during upload.

Free text

Select the cell and type a value. If a certain format is required, for example for adding a date, instructions are provided in the column heading.

Dropdown list - single choice

  • Click the arrow and select a value from the list.
  • For some dropdown lists values may differ according to user privileges.

Dropdown list - multiple choice 1

Multiple Choice in the column header indicates that more than one value can be selected from a dropdown list. The options are listed in the Multiselect bar.

To choose more than one option:

  1. Select the cell.
  2. Click Select Multiple Options > Display Multiple Options .

  1. In the Multiselect bar:

    1. If the bar still displays a previously selected list, click Refresh.
    2. Click the required values and then click Select.

The values are listed in the text bar for the selected cell.

Dropdown list - multiple choice 2

Multiple Choice in the column header indicates that more than one value can be selected from a dropdown list. The options are listed in the Multiselect bar.

To choose more than one option:

  1. If the Multiselect bar is not already open from a previous selection:

    1. Select the cell.
    2. Click Select multiple options > Display Multi-select list.

    3. In the Multiselect bar, click the required values and then click Select.
  2. If the Multiselect bar is open from a previous selection:

    1. Select the cell and then click Refresh.
    2. Click the relevant values and then click Select.

The values are listed in the text bar for the selected cell.

Dropdown list - icons

Icons are listed by JPEG filename. If no icon is selected, a default icon defined by your organization will be used.

To see an icon:

  1. Select the filename from the dropdown list.

  2. Hover over the link in the cell to display the edit bar.

  3. Click the link in the edit bar to display the icon.

Address, POI and Lattitude & Longitude fields
  • Include city and country in the Address cell to minimize auto-correct errors and enhance accuracy.
  • Adding an address auto-completes Latitude and Longitude if these cells are empty.
  • If both the Address cell and Latitude and Longitude cells have values, Latitude and Longitude take precidence.